Getting Started: Data Catalog
  • 20 Jan 2023
  • Dark
    Light
  • PDF

Getting Started: Data Catalog

  • Dark
    Light
  • PDF

Article Summary

Note

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.

  1. Click Account Users > Settings
    image

  2. Click Edit User You Want to Set
    image

  3. Enable the use of the Data Catalog function and click Save.
    image

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.

Reauthenticate your account

You can also reauthenticate your account later.
For details, refer to Datastore Linkage Management.

If you are using it for the first time in your TroCCO account

The following screen is displayed when the Data Catalog screen is displayed.
Click on your datastore.
image

Verify your Google account

If you are using BigQuery, please refer to the procedure below.

  1. Verify your Google account and click Get Started
    image
If you are using it for the first time in your TroCCO account

A screen containing Authenticate as an administrator appears.
In this case, select Authenticate as an administrator, authenticate your Google account, and click Get started.
image

For administrators, refer to the specifications for metadata retrieval.

  1. Click the email address registered with trocco
    image

  2. Click Allow
    image


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.
image

Authenticating Snowflake Accounts

Enter the required information, then click Authorize your Snowflake account and click Get Started.
image

If you are using it for the first time in your TroCCO account

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.
image

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.
userPlease enter your Snowflake username.
passwordEnter 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.
Host name input format
  • 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.
    image

  • An example of input based on the above screen is as follows.

    • *******-km*****.snowflakecomputing.com
    • hm*****.ap-northeast-1.aws.snowflakecomputing.com

Was this article helpful?