Forum Discussion

mark_ledwich's avatar
mark_ledwich
Regular Visitor
9 years ago
Solved

Dataset creation in DirectQuery mode and the Snowflake data source

I am trying to use the API to create a dataset with relationships and measures with a direct query connection to snowflake.   However i have reached different limitations with both th epublic and e...
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    mark_ledwich

     

    That scenario can be the only approach, to implement "no human interaction", you could schedule your C# script to run in a certain interval. When adding rows, do note the API limitation.

    I have no idea on any ETA, just keep one eye on the developer blog.

mark_ledwich's avatar
mark_ledwich
Regular Visitor
9 years ago

I want to use the API to create a dataset (with relationships, aggregation options, measures etc..) in direct query mode to the SnowFlake data source.

 

This is my understanding of current limitations of API's that prevent me from doing this:

 

Embedded:

  • Only supports the simpler dataset creation (just tables and columns). 
  • Allows import of a model in direct query. But only can update them for Azure SQL/DW (not snowflake) as mention in the FAQ

 

Public:

  • Supports the new featured dataset creation but thre is no way to modify the data source to be in Direct Query mode or specifiy the connection string.

 

Questions

  • is my understanding correct?
  • when will the API's support data set creation in direct query mode
  • when will the snowflake data source be supported for creation/modificaiton in the API

 

Thanks!

Mark