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
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 serve ...
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 ...
HubSpot: 414 Request-URI Too Large & 400 Request Header or Cookie Too Large
This error occurs when the object you are querying contains too many custom fields. To resolve this issue for ContactListContacts, Contacts, and Deals objects, enable the Column-wise chunking option in the HubSpot connection editor (located under ...
Integration Failure Types in Skyvia Data Integration
When using Skyvia Data Integration product, you may encounter two distinct types of integration failures: 1. Record-Level Errors These occur when one or more individual records fail to process during an integration task. For example, in operations ...
Freshdesk: The Limit of Freshdesk API Calls Per Hour Has Been Reached
This error occurs on the Freshdesk side, indicating that the API call limit for the hour has been exceeded. For more details on Freshdesk's API limits, refer to their API documentation. Freshdesk enforces a limit on the number of API calls that can ...