I have table in snowflake in lower case , my table name is fulltransactions but when I use snowflake connector is converting my select * from DATA.PUBLIC.fulltransactions to select * from DATA.PUBLIC.FULLTRANSACTIONS thus I get response as no table found or not authorised.
What might be the reason behind it?
As stated in the comment, please try this:
select * from DATA.PUBLIC."fulltransactions";
test:
CREATE OR REPLACE TABLE "fulltransactions" (col1 varchar);
INSERT INTO "fulltransactions" values('test');
SELECT * FROM SNOW_SANDBOX.PUBLIC.FULLTRANSACTIONS;
SQL compilation error: Object 'SNOW_SANDBOX.PUBLIC.FULLTRANSACTIONS' does not exist or not authorized.
SELECT * FROM SNOW_SANDBOX.PUBLIC."fulltransactions";
| COL1 |
|---|
| test |
If you would like to make your table not require case sensitivity you can rename the table:
ALTER TABLE "fulltransactions" RENAME TO FULLTRANSACTIONS;
Rerunning the original query now works:
SELECT * FROM SNOW_SANDBOX.PUBLIC.FULLTRANSACTIONS;