In some cases, as a result of Replication, in addition to the main tables (for example, dbo.Account ), empty additional tables are created in the database with names of the following types:
dbo.Account_2ade4447_5e11_4308_9e81_5eab62d9ed52
dbo.Account_7c473919_0b04_4c82_a993_e8445843bac4
dbo.Account_8220931f_c341_45aa_a4ec_ddd3fce83936
dbo.Account_96dc6902_1dc6_413d_a206_f116f076130b etc.
These are temporary tables that Skyvia creates during Replication, where data is temporarily transferred, and merged with the main table, after which these tables are deleted. The user should not see these tables, but if they do, there are two possible explanations:
1) Replication has not finished its work yet and that's why they have not been deleted yet, and when it finishes, it will clean up everything.
2) The user from his connection to the database, has no permissions to DROP TABLE operation and Replication can not delete them after itself. Then you need to give such rights to the user, and delete the already left tables manually.
In such cases, it is also recommended to update the Skyvia Agent. More details can be found via this link. Related Articles
Advantages of the New Replication Runtime Compared to the Old Runtime
The new replication runtime offers several key advantages: • Object-level LastSyncTime, enabling incremental replication for each object • New runtime modes: Standard, Resync, and Resync on Demand • Improved performance by removing direct ID checks ...
HubSpot: hapikey Permission Error
This issue is common when working with HubSpot. It typically occurs for the following reasons: The customer does not have access to the Marketing or CRM portal due to HubSpot subscription limitations and is limited to the Developer portal. The ...
Skyvia Backup Errors Caused by Salesforce API Requirements
Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API. For example, when Skyvia performs a backup or replication, it queries all the ...
Understanding Records in Skyvia Data Integration
1.1 Understanding Records in Skyvia Data Integration A record in Data Integration represents a single row in a database table. Every integration process (Import, Replication, Export, Synchronization, etc.) handles individual records. Records also ...
Salesforce Connect: Can't Sync the Schema Metadata for Your External System – Check That the Schema Metadata Is Valid. Error Code: Null
This error occurs because the object used in your endpoint does not have a primary key column. Salesforce requires a primary key for external objects, which is why you encounter an error when validating and syncing your External Data Source in ...