Destination Improvement: Allow User to set "name_in_destination" for tables
Answered
We have this table name in AWS DynamoDB: demo5-account-account-S2CJC1DEJ0II, its created by AWS CDK to be unique. For DBT multi environment, we really only need "account-account".
Fivetran turns this into: demo_5_account_account_s_2_cjc_1_dej_0_ii
We hate this name demo_5_account_account_s_2_cjc_1_dej_0_ii.
We want to set the name ourselves to "account_account"
* we remove the instance name demo5 off the front
* we remove the unique guid S2CJC1DEJ0II off the back
This allows DBT code to just say source is "account_account"
Via the API, I have set name_in_destination:
"demo5-account-account-S2CJC1DEJ0II": {
"enabled": "true",
"name_in_destination": "account_account",
"sync_mode": "SOFT_DELETE"
},
there is no error
there is no change
there is now a feature request!
-
Official comment
Hi Ann,
name_in_destination is not a settable field, it's a read-only response, so we ignore it. Being able to set the name would be interesting though! I'll add it to our backlog.
Jimmy
Please sign in to leave a comment.
Comments
1 comment