External Table in dedicated Pool

Rohit Kulkarni 676

Hello Team,

I have connected the data bricks with synapse analytics and Blob Storage with JDBC connecting string, And run the create external table syntax the script ran successfully.
But not able to see the external table in synapse analytics or SSMS.

Databricks script :

Synapse Analytics :

I am not able to see the table in the list

Please advise.

Regards
RK

BhargavaGunnam-MSFT 26,306 Reputation points Microsoft Employee

2022-09-23T23:19:33.107+00:00

Hello @Rohit Kulkarni ,

Welcome to the MS Q&A platform.

Could you please confirm if you were able to query the table from your dedicated pool? I saw a similar issue sometime back when the table limit was more than 20 tables, and the problem got resolved by itself.
Rohit Kulkarni 676 Reputation points

2022-09-24T09:21:45.73+00:00

Yes in dedicated pool it is working. Once again i have added the synatx.

CREATE EXTERNAL TABLE Salesforce.Accountaa
(
Id string ,
IsDeleted bigint,
Name string ,
Type string ,
RecordTypeId string ,
ParentId string ,

BUID__c string ,
CompanyName__c string ,
CreditLimit__c float,
CreditOnHold__c bigint,
CustomerClassification__c string ,
DUNSNumber__c string ,
DepartmentLabel__c string ,
DepartmentName__c string ,
DepartmentType__c string ,
DiscountGroup__c string ,
DoNotAllowBulkEmails__c bigint,
Email__c string ,
EnglishCompanyName__c string ,
Interest__c string ,
Language__c string ,
LastCheckedBy__c string ,
LastCheckedOn__c float,
MarketOrganization__c string ,
OtherPhone__c string ,
PaymentTerms__c string ,
Price_Book__c string ,
RecordType__c string ,
RelatedToGlobalKeyAccount__c bigint,
RequestDeletion__c bigint,
RequestEdit__c bigint,
Segment__c string ,
ShippingCountry__c string ,
Subsegment1__c string ,
Subsegment2__c string ,
TermsOfDelivery__c string ,
Status__c string ,
SynchronizeBillingAddress__c bigint,
Target_Account__c bigint,
TravelZone__c string ,
DynamicsAutoNumber__c string ,
Goal__c string ,
OriginOfData__c string ,
CustomDUNS__c string ,
TAP_Description__c string
)
using parquet
location 'abfss://Storagename@Conatinername.dfs.core.windows.net/Bronze/Salesforce/Account/*'
BhargavaGunnam-MSFT 26,306 Reputation points Microsoft Employee

2022-09-26T19:31:13.037+00:00

Hello @Rohit Kulkarni ,

When you say, "Yes in dedicated pool it is working." Do you mean it's working in synapse studio but not using SSMS?

Could you please test if you can query "select top 10 * from Salesforce.Accountaa"?
BhargavaGunnam-MSFT 26,306 Reputation points Microsoft Employee

2022-10-04T23:40:58.947+00:00

Hello @Rohit Kulkarni ,
I am just checking in to see if you have any updates here.