Hi @Mario_Gonzalez Thanks for your inquiry. I believe there are 2 separate topics here: 1 there is an error with a particular column “client_additionalQuestions” and this could be because it isn’t in the sql schema, but from the screenshots it’s hard to tell if this is what is going on. Are you getting this error with a “Select * from table”? This part is unclear to me.
And 2, you are comparing the differences between the BI Connector relational schema representation and Atlas SQL, which doesn’t provide the same rendering of the data. This is by design and users can use SQL to transform (flatten, unwind, cast) the data.
Here is an example of SQL I pass in through the connector or you can put it in Mcode in Power Query:
Select Cast(_id as string) as _id,
couponUsed, customer_age, customer_gender, customer_satisfaction,
items_name, items_price as price, items_quantity,
(items_quantity * items_price) as totalPrice,
storeLocation, saleDate, purchaseMethod ,
cast(saleDate as Timestamp)as testDateTimestamp,
SUBSTRING (Cast(DATETRUNC(DAY,saleDate)as string),0,10) as DateOnly
from Flatten(Unwind(Supplies.Sales with Path=>Sales.items))
where items_quantity = 2
limit 100
If you can email me, we can figure out the error and I can guide you in a bit more targeted way. Also, I can point out some references on Atlas SQL that helps show the differences and how to adjust usage. Alexi.antonino@mongodb.com