Error when getting data using SQL statement from Snowflake?

[ERing]

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?

[v-tangjie-msft]

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

[divyed · Accepted solution]

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

[danextian]

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?

[ERing]

I am using the "Get Data" option.

[danextian]

What I meant was is that an existing query and you're simply editing the connection or a totally new one without additional steps other than the source and navigation?