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”