Forum Discussion
Error when getting data using SQL statement from Snowflake?
I'm trying to bring data into my Power BI model from Snowflake using a SQL statement. I've entered the Server, Warehouse, and Database along with the SQL statement, but it keeps returning the error message below.
This is the SQL statement.
select os.*,oa.* FROM PRODUCTION.MARKETING.DIMENSONS_ORDERSSUMMARY OS
inner join PRODUCTION.MASTER_DIMENSIONS.DIMENSIONS_ORDERAPPOINTMENTS oa on oa.order_id=os.fk_order_id and oa.location_type=os.location where os.FK_ORDER_ID is not null and oa.status_=1
Can anyone help me understand what is causing this?
Hello ERing ,
This is giving error while connecting. You are selecting everything from both the tables (os.* and oa.*) and most probably "Field ID " is present in both the table. I would suggest selecting required columns only with corresponding reference like oa.order_ID as Order_ID, os.location as Location etc.
I hope this helps .
Did I solve your problem, if yes please mark this as solution.
Cheers
5 Replies
That is normally the error if you're trying to create a column which name already exists? Are you building the query in the query editor from scratch or just editing the source applied step?
Hello ERing ,
This is giving error while connecting. You are selecting everything from both the tables (os.* and oa.*) and most probably "Field ID " is present in both the table. I would suggest selecting required columns only with corresponding reference like oa.order_ID as Order_ID, os.location as Location etc.
I hope this helps .
Did I solve your problem, if yes please mark this as solution.
Cheers
Hi ERing ,
Did divyed and danextian suggestions solve your confusion, and if the problem has been solved, you can mark the standard answer in your reply to help other members find the answer faster. If not, please point it out.
Best Regards,
Neeko Tang
