reload data from SQL-connection

hop
hop Registered Posts: 5 ✭✭✭

Hi,

I have connected to an MS SQL Server and I am extracting data on a daily basis in one of my projects. How can the data I'm extracting be reloaded automatichly - lets say every morning?

Henrik


Operating system used: Windows 10

Tagged:

Best Answer

  • dgraham
    dgraham Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 16 Dataiker
    Answer ✓

    Hi @hop
    ,

    The error occurs because the connection of the dataset does not have permission to create tables in the SQL database. The simplest solution is to grant the user that is specified in the connection create table permission in the database.

    In order to update or write data into a SQL datasets, DSS first drops the table > it then creates the table > and finally inserts the data. You could change this behavior such that table creation occurs only if the table doesn't already exist in the database by enabling the "Truncate to clear data" option in the setting of the connection. With this option enabled, DSS creates the table if it doesn't already exist, table creation is skipped if the table already exists > it then checks whether the table schema matches the current schema of the dataset in DSS > if it matches, it truncates the table > then inserts the data. Note, if the table and dataset schemas are different, then the write operation will error.

Answers

  • hop
    hop Registered Posts: 5 ✭✭✭

    Okay so I found out that the data will be reloaded when I rebuild the flow. But when I try to rebuild I get the error

    'CREATE TABLE permission denied in database'

    How do I solve this?

Setup Info
    Tags
      Help me…