Nicolas P
09/25/2024, 6:25 AMDatasetError: Failed while saving data to data set ManagedTableDataset(catalog=dev-catalog, database=my_database, dataframe_type=pandas, primary_key=['content_id', '"From yyyy-mm-dd hh:mm"'], table=my_table, version=None, write_mode=upsert).
[PARSE_SYNTAX_ERROR] Syntax error at or near '"From yyyy-mm-dd hh:mm"'. SQLSTATE: 42601 (line 1, pos 212)
== SQL ==
MERGE INTO `dev-catalog`.`my_database`.`my_table` base USING update ON base.content_id=update.content_id AND base."From yyyy-mm-dd hh:mm"=update."From yyyy-mm-dd hh:mm""
I tried to set the primary key using the following syntaxes:
primary_key:
- content_id
- "From yyyy-mm-dd hh:mm"
primary_key:
- content_id
- "`From yyyy-mm-dd hh:mm`"
primary_key:
- content_id
- '"From yyyy-mm-dd hh:mm"'
but none seems working.
Would you have any ideas?
Thx!Nicolas P
09/25/2024, 10:48 AMprimary_key:
- content_id
- "`From yyyy-mm-dd hh:mm`"
actually worked.