Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,562 questions
Error generated when I try to Import Schema into Dataflow from Dataverse Lake Database tables -
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 7.000000000000001%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
Josue Preciado Preciado
1
Reputation point
I can successfully query the tables in our Lake Database using SQL but I cannot import the schema from any tables using Dataflows. Every time I import the schema during debug, I get the following "import error message"
I have admin rights in the workspace and I have owner role in our Blob Storage.
Here's the workflow and error:
org.apache.hadoop.hive.ql.metadata.HiveException: java.lang.NullPointerException;
Azure Data Lake Storage
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,378 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator2022-09-26T23:40:52.85+00:00 Hello @Anonymous ,
Welcome to the MS Q&A platform.
Could you please let us know whether this issue is specific to one table (or) are you having this issue across all tables in the lake databases?From my end, I can able to preview data on any lake databases using dataflow
-
Josue Preciado Preciado 1 Reputation point
2022-09-28T16:25:08.327+00:00 It is happening to all tables unfortunately. We will test recreating the workspace to see if something was deployed incorrectly.
-
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2022-09-29T00:20:56.993+00:00 Hello @Anonymous ,
Thank you for the update. I checked on all my lake DBs and not seeing this issue. Maybe it could be a schema issue?
Could you please create a simple test table and see if you see the same behavior?
Please let me know if you need any further help here. -
Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
2022-10-04T23:42:56.113+00:00 Hello @Anonymous ,
I am just checking in to see if you were able to resolve the issue with re-creating the workspace. In case if you still need any further assistance, please let us know.
Sign in to comment
Sign in to answer