- 20 Jan 2023
- 1 Minute to read
- Print
- DarkLight
Getting Started: Data Catalog
- Updated on 20 Jan 2023
- 1 Minute to read
- Print
- DarkLight
This is a machine-translated version of the original Japanese article.
Please understand that some of the information contained on this page may be inaccurate.
This is a summary of the steps required to use the Data Catalog for the first time.
Data Catalog user settings
In order to use the Data Catalog, you must be a Data Catalog user.
If you have trocco administrator privileges, follow the steps below.
Click Account Users > Settings
Click Edit User You Want to Set
Enable the use of the Data Catalog function and click Save.
Account verification
From the left side menu of Trocco, click Data Catalog.
In the following steps, you'll authenticate your account. Refer to the instructions for your datastore.
You can also reauthenticate your account later.
For details, refer to Datastore Linkage Management.
The following screen is displayed when the Data Catalog screen is displayed.
Click on your datastore.
Verify your Google account
If you are using BigQuery, please refer to the procedure below.
- Verify your Google account and click Get Started
A screen containing Authenticate as an administrator appears.
In this case, select Authenticate as an administrator, authenticate your Google account, and click Get started.
For administrators, refer to the specifications for metadata retrieval.
Click the email address registered with trocco
Click Allow
Depending on the usage situation, the following screen may be displayed instead of the above.
In this case, enable all the checkboxes and click Continue.
Authenticating Snowflake Accounts
Enter the required information, then click Authorize your Snowflake account and click Get Started.
A screen containing Authenticate as an administrator appears.
In this case, select Authenticate as an administrator and click Authorize your Snowflake account and get started.
For administrators, refer to the specifications for metadata retrieval.
Snowflake Account Authentication Inputs
Item nameRequired | content | |
---|---|---|
host | ✓(*) | Enter the Snowflake host. *This item is displayed when you select Authenticate as an administrator. |
user | ✓ | Please enter your Snowflake username. |
password | ✓ | Enter your Snowflake password. |
Warehouse | - | Enter the warehouse. The query is executed on the warehouse entered in this field. |
roll | - | Enter the role in which you want to execute the query. The query is executed based on the role entered in this field. |
You can enter it in one of the following formats:
<組織名>-<アカウント名>.snowflakecomputing.com
<アカウントロケーター>.<リージョン>.<クラウド>.snowflakecomputing.com
Each of the above elements can be found in the upper right corner of the Snowflake classic console screen.
An example of input based on the above screen is as follows.
*******-km*****.snowflakecomputing.com
hm*****.ap-northeast-1.aws.snowflakecomputing.com