Hi everyone,
I encounter a strange error.
I try to insert the following:
INSERT INTO "usertable.virtualtable::VT_usertable" (
"ID", -- integer
"name", -- NVARCHAR(128)
"birthday", -- date
"account_balance") -- decimal
VALUES (1, myname, 202001...
Hi there,
I have a couple of virtual tables and I want to deploy my application on several spaces with different remote databases.
When im deploying my application first of all I have to manually replace my RemoteSource and DatabaseName within th...
Hi Mickael,thanks for bring clarity to this topic.The remote source is already created and with this a database name exists you are correct about this.I im not sure if just "database.configure" would just work like *magic* because the remote source i...
Now I had to time to test it it actually works like this.I used the virtualtableconfig wrong and used the TableOne twice. This is corrected now in the example below.########### virtualtable config ###########
db/src/cfg/example.virtualtableconfig
{
...
Hi Mickael,Im still confused but on another level.I feels like im missing something because im already using synonyms and it seems like "schema.configure" can access them actual schema dynamically. But I dont have a configure file! And when I want to...
Hi Mickael,I added a comment on Florians answer.I not 100%sure if that already covers what you meant but I think so, please correct me if im wrong.Thanks for you answer!
Great thanks! From my understanding it should look like this now. Am I correct ?Is there a naming convention for the logical_schema? Example -> example-virtualtable-logical_schema########### virtualtable config ###########
db/src/cfg/example.virtual...
