too many dots in table name error

Question

Hello, I am trying to create a table in a query fabric database. I have successfully connected to it and have access to all of the databases and schemas.

I am trying to use this as a test:

create table user_space.dx_dl_qf_nedvfcollections.T_TEST as

(select * from DX.JRNL_CSG_PII.SBB_BASE limit 10)

This query works when I run it in dbeaver or toad, but Alteryx throws this error:

I only have dots separating the database and schema, so I am not sure why i am getting this error.

Any help would be greatly appreciated!

dreldrel · Answer

It is always good to test the query on your database side first to ensure it works. Normally, it works on Alteryx if you validate before

binu_acs · Answer

@Joseph_Peterson may try to use the double quotes

CREATE TABLE user_space.dx_dl_qf_nedvfcollections.t_test AS
SELECT * FROM "DX"."JRNL_CSG_PII"."SBB_BASE" LIMIT 10;

Gaurav_Dhama_ · Answer

Once you have connection to the database, i don’t think you need to mention the database again in the query.

Try using just the table name, and if schema isn’t selected, maybe just use the schema along with name.

i am currently on phone, so cannot validate it. But do let us know if this didn’t help.