google cloud platform - Dataform import json config - Stack Overflow

admin管理员组

文章数量:1410689

I'm having trouble importing configurations into my sqlx.

I created the dataform_cofig.json file

{
"database": "Proj-svil-001-prj",
"schema": "TRY_IMM"
}

I would like to bring them into my try.sqlx file

config {
type: "table",
description: "Create table ."
}
 
CREATE OR REPLACE TABLE
${database}"."${schema}.TABLE_TRY

but I can't import them what am I doing wrong? I'm just starting to use the tool

I'm having trouble importing configurations into my sqlx.

I created the dataform_cofig.json file

{
"database": "Proj-svil-001-prj",
"schema": "TRY_IMM"
}

I would like to bring them into my try.sqlx file

config {
type: "table",
description: "Create table ."
}
 
CREATE OR REPLACE TABLE
${database}"."${schema}.TABLE_TRY

but I can't import them what am I doing wrong? I'm just starting to use the tool

• google-cloud-platform
• dataform

Share Improve this question Follow asked Mar 11 at 15:18 prototype sqlprototype sql 5155 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

Kindly take note of the limitation in dataform. The JSON config file can’t be directly imported to Dataform’s SQLX files.

Here are some things you need to check on your project:

• Check if your .json config file is accessible in your Dataform project.

• Manually load the configuration in your SQLX, it is best to store your .json file in BigQuery and load it using SQL query in your Dataform project.

This is interesting to be available natively. On Google side, there is a feature request that you can file but there is no timeline on when it can be done.

本文标签： google cloud platformDataform import json configStack Overflow