Write IN-Db tool

[Nandakishore]

Hi ,

Can someone help me with correct syntax of table  name field in Write In DB tool .

Thanks

 

[caltang]

????

What? What do you mean correct syntax? What are you even trying to do my friend?

[apathetichell]

check the syntax on the db/schema/table you are pulling in from in-db and replicate. is it:

db.table

is it db.schema.table

is it "db"."table" - etc... 

[apathetichell]

Also - worth asking - what type of Db syntax are you writing to. There is at least one outlier (Databricks) where you can read In-DB but only write via datastream-in.

[Nandakishore]

Hi @caltang  , 

I mean table name how this need to be provided . 

Example : 

db.tablename 

or 

[db].[tablename]

etc .

Thanks

[simonaubert_bd]

Hello @Nandakishore 

Usually it's
yourbase.yourtable or yourschema.yourtabke

If you have special characters, you may need enclosing character such as
"yourbase"."yourtable"
or on hadoop
`yourbase`.`yourtable`

if you have set a default database, you can even use directy yourtable.

Best regards,

Simon