io_config.yaml
.default
(you can
have multiple profiles, add it under whichever is relevant to you)GOOGLE_SERVICE_ACC_KEY
or the
value for key GOOGLE_SERVICE_ACC_KEY_FILEPATH
(both are not simultaneously
required. If you use GOOGLE_SERVICE_ACC_KEY_FILEPATH
, please delete GOOGLE_SERVICE_ACC_KEY
in the io_config.yaml
).SQL
.Data provider
dropdown, select BigQuery
.Profile
dropdown, select default
(or the profile you added
credentials underneath).Database
label, enter the database name you want this block to
save data to.Save to schema
label, enter the schema name you want this block
to save data to.Write policy
dropdown, select Replace
or Append
(please see
SQL blocks guide
for more information on write policies).SELECT 1
.Generic (no template)
.config_profile
from default
if
you have a different profile):overwrite_types
dict in data exporter config.
You can find the supported types in this doc. Here is the example code: