I have a database with a hyphen like this: DATABASE-NAME. For this to work on snowflake I would have to use "DATABASE-NAME"."SCHEMACHANGE" but I can't make the application to grab it.
If I pass it without the quotes, it returns me a syntax error line 1 at position 38 unexpected '-'.
If I pass with the quotes it returns me a
raise ParserError("while parsing a block mapping", self.marks[-1] ...
change-history-table: "DATABASE-NAME"."SCHEMACHANGE"."CHANGE_HISTORY"
I also tried to manually create the table and then ask to not created when running the application, but then when querying it, it won't find it and returns me the same error. I really would like some insight on how to make this work.
eaguilera23
commented
1 year ago
Hello.
I have a database with a hyphen like this:
DATABASE-NAME. For this to work on snowflake I would have to use"DATABASE-NAME"."SCHEMACHANGE"but I can't make the application to grab it.If I pass it without the quotes, it returns me a
syntax error line 1 at position 38 unexpected '-'.If I pass with the quotes it returns me a
I also tried to manually create the table and then ask to not created when running the application, but then when querying it, it won't find it and returns me the same error. I really would like some insight on how to make this work.
Thank you