Forum Discussion

Meerashahul2024's avatar
Meerashahul2024
Regular Visitor
1 year ago
Solved

Fabric -SQL command in Microsoft Data Warehouse

I recently encountered an error while attempting to execute an SQL command in Microsoft Data Warehouse. The command could not be executed successfully, and I am trying to determine the cause of the issue. any thoughts?

  • lbendlin's avatar
    lbendlin
    1 year ago

    There is a non-deterministic lag between the creation of an artifact in the DW and the availability of that artifact in the SQL endpoint. Can be anything from 10 minutes to "a couple of hours".

6 Replies

  • It would help if you could provide a sanitized version of the SQL query.

  • Sometime facing issue when run the table , Lets say Select * From employee table which is already created in DW

    • lbendlin's avatar
      lbendlin
      Super User

      There is a non-deterministic lag between the creation of an artifact in the DW and the availability of that artifact in the SQL endpoint. Can be anything from 10 minutes to "a couple of hours".

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Meerashahul2024,

    Thank you for reaching out in Microsoft Community Forum.

    Thank you lbendlin  for the helpful response.

    As suggested by Ibendlin, I hope this information was helpful. Please let me know if you have any further questions or you'd like to discuss this further. If this answers your question, please "Accept as solution" and give it a 'Kudos' so others can find it easily.

    Please continue using Microsoft community forum.

    Regards,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Meerashahul2024,

    I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, kindly "Accept  as  Solution" and give it a 'Kudos' so others can find it easily.

    Thank you,
    Pavan.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Meerashahul2024,


    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.


    Thank you,
    Pavan.