Error while creaing extract from tableau


#1

I am getting a constant error re bad connection whenever I am trying to create an Tableau extract of the while connected to dremio. I intend to create an extract so that its easier and fast while visualizing data in tabeau and hopefully do an incremental refresh based on time.
the error I am receiving is like below
An error occurred while communicating with the Other Databases (ODBC) data source ‘Prod_leads_overal_new (@nitish.soman@sensis.com.au.Prod_leads_overal_new) (localhost)’.

Bad Connection: Tableau could not connect to the data source.
[Dremio][Connector] (1040) Dremio failed to execute the query: SELECT “Prod_leads_overal_new”.“BsuinessId” AS “BsuinessId”,
“Prod_leads_overal_new”.“Lead_Id” AS “Lead_Id”,
“Prod_leads_overal_new”.“NotInterested_Reason” AS “NotInterested_Reason”,
“Prod_leads_overal_new”.“id" AS “Xid”,
“Prod_leads_overal_new”.“advertiserScore” AS “advertiserScore”,
“Prod_leads_overal_new”.“businessId” AS “businessId”,
"Prod_leads_overal
…[see log]
Unable to create extract
SELECT “Prod_leads_overal_new”.“BsuinessId” AS “BsuinessId”,
“Prod_leads_overal_new”.“Lead_Id” AS “Lead_Id”,
“Prod_leads_overal_new”.“NotInterested_Reason” AS “NotInterested_Reason”,
“Prod_leads_overal_new”.”_id" AS “Xid”,
“Prod_leads_overal_new”.“advertiserScore” AS “advertiserScore”,
“Prod_leads_overal_new”.“businessId” AS “businessId”,
“Prod_leads_overal_new”.“createdAt” AS “createdAt”,
“Prod_leads_overal_new”.“displayId” AS “displayId”,
“Prod_leads_overal_new”.“distance” AS “distance”,
“Prod_leads_overal_new”.“gmailMessageId” AS “gmailMessageId”,
“Prod_leads_overal_new”.“leadId” AS “leadId”,
“Prod_leads_overal_new”.“notifiedAt” AS “notifiedAt”,
“Prod_leads_overal_new”.“openedAt” AS “openedAt”,
“Prod_leads_overal_new”.“quoteBudget” AS “quoteBudget”,
“Prod_leads_overal_new”.“quoteCategory” AS “quoteCategory”,
“Prod_leads_overal_new”.“quoteDescription” AS “quoteDescription”,
“Prod_leads_overal_new”.“quoteLocation” AS “quoteLocation”,
“Prod_leads_overal_new”.“quoteTimeframe” AS “quoteTimeframe”,
“Prod_leads_overal_new”.“quotedListing” AS “quotedListing”,
“Prod_leads_overal_new”.“requestedSuburb” AS “requestedSuburb”,
“Prod_leads_overal_new”.“respondedAt” AS “respondedAt”,
“Prod_leads_overal_new”.“round_number” AS “round_number”,
“Prod_leads_overal_new”.“sourceUrl” AS “sourceUrl”
FROM “@nitish.soman@sensis.com.au”.“Prod_leads_overal_new” “Prod_leads_overal_new”


#2

I’ll defer to others on this particular error. However, are you familiar with Data Reflections? A popular use case is to use Data Reflections instead of extracts, giving you similar or better performance, but for any tool, not just Tableau, and without the scaling limitations of extracts.