Question

Azure Writer keeps giving me an create table error when I'm trying to insert

  • 14 February 2020
  • 1 reply
  • 12 views
N

Hello Everyone,

I am trying to write some structured data into an existing table into AZURE. The table is already created but there is no data in the tables. I have set up the connections and have the correct table name so no issue there. Also, the fields I am trying to write match the naming conventions of the AZURE table.

As you can see from the screen shot below I have chose insert but I am receiving this error message ( below screenshot)

 

 

0.0|ERROR |Microsoft Azure SQL Database Non-Spatial Writer: Failed to create Azure table 'siro_stg.MAD' because no clustered index or primary key was specified. If creating a new table, go into the 'User Attribute' tab and set the 'Index' column to 'clustered', 'clustered_not_null', or 'primary_key' for a column

The AZURE DB table has no primary key set or indexing. I was told this shouldn't matter as we are treating this as a staging area table.

Not sure why this error is appearing as I'm not trying to create a table just insert into a pre existing one. I have also tried update and selecting all matched rows but the same error is appearing.

Any Ideas what I'm missing for this workspace to run successfully?

 

I can supply the work space if needed for further clarity.

 

Thanks!

1 reply

nampreetatsafe
Rank
Userlevel 1
Badge +10

Hi @neil1989! A couple things you can try:

1) Try placing siro_stg in the Table Qualifier parameter:

 

2) If the destination table is already created, have you tried adding the Writer feature type by Importing from Dataset and pointing to the siro_stg.MAD table on AZURE? If you've already created the Writer connecting to your Azure instance, you can do this by going to Writers > Import Feature Type, or if you want to do it from scratch, when adding the Writer, under Table Definition, select Importing from Dataset...:

Hope this helps!

Reply


Community Stats

28,709
Posts
109,484
Replies
36,556
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.