Alex Thornbury
- Total activity 23
- Last activity
- Member since
- Following 0 users
- Followed by 0 users
- Votes 4
- Subscriptions 7
Activity overview
Latest activity by Alex Thornbury-
Alex Thornbury commented,
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 ...
-
Alex Thornbury created a post,
INFORMATION_SCHEMA discovery script should be SET based not RBAR
Which destination?:Any PostgreSQL Destination (presumably this behavior is similar on any SQL database destination except for Oracle) Additional details: The following query is executed per table a...
-
Alex Thornbury commented,
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 ...
-
Alex Thornbury commented,
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...
-
Alex Thornbury commented,
<<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...
-
Alex Thornbury commented,
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...
-
Alex Thornbury created a post,
Improve Managing Fivetran related metadata
PlannedWhich connector?: At a minimum this pertains to fivetran_metadata and Salesforce related connections Additional details: These two connections (and possibly others) create multiple metadata related...
-
Alex Thornbury commented,
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...
-
Alex Thornbury created a post,
Destination Improvement: Bulk Change Sync Mode
AnsweredCurrently, the sync mode is set in an individual by table by schema fashion. This is fine when there is a small number of tables or schemas, but becomes frustrating when the number of schemas and t...
-
Alex Thornbury created a post,
Destination Improvement: Set a default sync mode for new tables
PlannedThe soft delete option is the default and will be applied to all tables added to a destination initially or in the future. We are defaulting to History Mode in our destinations and it is a pain to ...