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