Data Source - trocco
- 07 Dec 2022
- 1 Minute to read
-
Print
-
DarkLight
Data Source - trocco
- Updated on 07 Dec 2022
- 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.
summary
This page is a help page for setting up transferring data retained by the TroCCO Data Catalog function.
constraint
- To transfer data from the Data Catalog, you must enable the Data Catalog feature.
- For more information about the Data Catalog feature, contact your sales representative or Customer Success.
Setting items
STEP1 Basic settings
| Item nameRequired | content | |
|---|---|---|
| target | Yes | Select the target you want to transfer from the following.
|
| Data | Yes | Select the data type you want to transfer from the following.
|
STEP2 Advanced settings
There are no advanced settings for this transfer source.
Transfer Items
Attn: Data Catalog
Tables to transfer metadata to
基本メタデータユーザー定義メタデータ At least one of the forwards metadata for the entered table.
User-defined metadata
- User-defined metadata (BigQuery table information)
- Transfer metadata from
テーブル情報the Data Catalog.
- Transfer metadata from
- User-defined metadata (BigQuery column information)
- Transfer metadata from
カラム情報the Data Catalog.
- Transfer metadata from
| Column Name | Type | Description |
|---|---|---|
| bigquery_project_id | string | BigQueryに関するメタデータ ofプロジェクト |
| bigquery_dataset | string | BigQueryに関するメタデータ ofデータセット |
| bigquery_table | string | BigQuery table name |
| bigquery_column | string | BigQuery column names This item is transferred only when user-defined metadata (BigQuery column information) is selected as the data type. |
| trocco_metadata_logical_name | string | 基本メタデータof論理名 |
| trocco_metadata_description | string | 基本メタデータof説明 |
| trocco_metadata_last_updated_at | timestamp | 基本メタデータLast updated |
ユーザー定義メタデータ用テンプレートField name defined in | The data types defined in the template are the following types:
| ユーザー定義メタデータ Value of |
| user_defined_metadata_last_updated_at | timestamp | ユーザー定義メタデータ Last updated |
Column reference list
- Transfer metadata from
カラム参照the Data Catalog.
| Column Name | Type | Description |
|---|---|---|
| bigquery_src_project_id | string | The dependentBigQueryに関するメタデータ of theプロジェクト |
| bigquery_src_dataset | string | The dependentBigQueryに関するメタデータ of theデータセット |
| bigquery_src_table | string | The name of the BigQuery table on which it depends |
| bigquery_src_column | string | Column name of the dependent BigQuery |
| bigquery_dst_project_id | string | BigQueryに関するメタデータ Theプロジェクト |
| bigquery_dst_dataset | string | BigQueryに関するメタデータ Theデータセット |
| bigquery_dst_table | string | The name of the BigQuery table on which it depends |
| bigquery_dst_column | string | The column name of the BigQuery on which it depends |
| creation_type | string | How to create a column reference
|
| created_by | string | Author of column reference (email) |
| last_updated_at | timestamp | The last modified column reference |
Was this article helpful?