Forum Discussion

selsoft1907's avatar
selsoft1907
New Member
1 year ago
Solved

Generate some views create script

I have a Fabric Data Warehouse. I want to export some views create script into a SQL file. Basically generate script operation. Is it possible ?  This type of scripts is not working: SELECT s.name...
data engineering
Lakehouse
  • smeetsh's avatar
    smeetsh
    1 year ago

    I ran the script (without the where and order by clause) and that works just fine in SSMS and the fabric UI.

     

    The '%TEST' may be invalid. Try running it without the where and see what the results are? PS Keep in mind it is case sensitive.

     

    What is it exactly what you are trying to achieve?

     

    Cheers

    Hans

  • v-dineshya's avatar
    v-dineshya
    1 year ago

    Hi selsoft1907 ,

    Thank you for reaching out to the Microsoft Community Forum.

     

    Hi smeetsh  Thank you for your prompt response.

     

    Hi selsoft1907 , As mentioned by smeetsh , please provide more details about your issue and what you are trying to achieve.

     

    Regards,

    Dinesh

smeetsh's avatar
smeetsh
Continued Contributor
1 year ago

I ran the script (without the where and order by clause) and that works just fine in SSMS and the fabric UI.

 

The '%TEST' may be invalid. Try running it without the where and see what the results are? PS Keep in mind it is case sensitive.

 

What is it exactly what you are trying to achieve?

 

Cheers

Hans

  • selsoft1907's avatar
    selsoft1907
    New Member
    1 year ago

    I fix the issue. The reason behind ssms. When I run this script it return space for view definition column. However when I run under fabric portal it returns data. Maybe reason is permissions.