Alex Thornbury
- Total activity 25
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 4
- Subscriptions 8
Comments
Recent activity by Alex Thornbury-
Managing the partitions with pg_partman's maintenance script drops the oldest partition and successfully creates the newest future partition based on the table settings in pg_partman's part_config ...
-
The fivetran_metadata Connector is optional, but requires an opt-out as far as I know. In other words, you create a Connector and the fivetran_metadata Connector is created automatically, then you ...
-
After I have all of the affected clusters in an initial good state, then the frequency of the maintenance will be monthly going forward. However, it will require two different mechanisms at present...
-
<<salesforce>>.fivetran_query on the other hand will not currently support this option. The candidate column, start, is scoped as NULLABLE and is not part of the existing primary key constraint. It...
-
Sadie- We are trying to keep a rolling three months of data in these tables. I currently have 9 PostgreSQL destinations. All of these have one or more Connection from a Salesforce source and 8 of...
-
This is especially true for the tables that Fivetran adds for replication from Salesforce. Tables like fivetran_api_call and fivetran_query get large. Deletion is a hassle while partition managemen...