[SOLVED] Dataform import json config

Dataform import json config

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

Solution

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.