With Synapse Link, exported tables are created as external tables and I get a "Cannot find the CREDENTIAL" error when querying in SSMS. I have no problems running queries in Synapse. Short of doing a CREATE CREDENTIAL for every file created in the storage account (not even sure if that will work), what is the correct way of granting access to these external tables for SSMS?
@prachijain5955 - please share the error message with the Fabric team or create the support ticket for it. There can me multiple reasons, but for sure, we want to investigate it.
Eyo love the videos. Idea to put links to used resources in the description? If openly availabe. Keep up the good work!
Awesome 🎉
With Synapse Link, exported tables are created as external tables and I get a "Cannot find the CREDENTIAL" error when querying in SSMS. I have no problems running queries in Synapse. Short of doing a CREATE CREDENTIAL for every file created in the storage account (not even sure if that will work), what is the correct way of granting access to these external tables for SSMS?
8:40 yeap...a bit confusing...let's hope than OneSecurity will soon make the access control universal across Fabric Engines (spark/sql)
@GuillaumeBerthier we all are waiting for OneSecurity; you can find the roadmap here learn.microsoft.com/en-us/fabric/release-plan/
It would be more interesting if you could present with slides.
Qs - Spark Session Issue - mostly received unexpected errors in notebook, spark session issue. How should we need to handle?
@prachijain5955 - please share the error message with the Fabric team or create the support ticket for it. There can me multiple reasons, but for sure, we want to investigate it.