I’m just getting into Snowflake as my company is migrating from Teradata this year, so apologies if there some obvious seeming things I’m missing.
I’m trying to use the import wizard in DBeaver to import a TXT into an empty table I’ve already created. I’m getting an error “SQL Error 2003 02000: SQL compilation error: Schema . does not exist or not authorized”
No where in the connection information do I specify the database name twice, so DBeaver is generating that on its own somewhere behind the scenes.
Prior to this I was getting an error about not the session not having a database (I’d purposefully used “TEST_DB” which isn’t real as I will be using multiple databases on a regular basis for the reporting I’m doing).
What I’m hoping to get guidance on is how I can just write the actual INSERT statement SQL myself and just NOT use the import wizard. That way I can avoid whatever foul-ups DBeaver keeps doing when it generates the SQL.
Google searches haven’t turned up anything.
