If you're a user of Redshift, you know that sometimes you want to alter a column which already exists in your table. There's been no good, managed solution for that - until now!
We're proud to release the first version of alter column - column rename and varchar length change for Redshift!
From the Mapper screen, just change the name for a specific field, or hit the data type dropdown and change the varchar length. Apply the changes, and we'll do the work in the background to update all relevant tables and migrate your data to the new type!
We do this all in one transaction, so if anything fails you can be sure you won't be stuck in a weird state. Also, please note that because of Redshift behavior, if you shorten a varchar length it will trim any values that don't fit. We'll warn you about that fact in the UI as well :)
Not a user of Redshift? Want to change different data types? Those self-serve features are on their way! In the meantime, our support team can help you with any change.
NetSuite and Close.io beta
We're always adding new inputs, and this month is no different. If you're a user of NetSuite or Close.io, it's your lucky day! Read more about our new integrations:
Map to Multiple BigQuery Datasets
BigQuery datasets are an important component for how you organize your data in BigQuery. That's why we've added the ability to define which dataset you'd like your data to go into for each event type. By default, we'll write to the dataset you originally defined when connecting to your BigQuery.
You can find the ability to map to multiple datasets in two locations:
- When creating an input in OneClick mode, you can select the dataset the tables will automatically map to.
- When mapping a particular event type, you can select the target dataset from the dropdown to the left of the table dropdown.
We also give you the ability in both of those locations to create a new dataset to map to. Keep in mind that to do that, we'll need Editor permissions.
- The queries view on your output now not only shows all the consolidations you have running, but we've also added a Run Now button. This lets you perform an ad hoc execution of your consolidation query, exactly when you want it.
- We've added support to the Binary data type for both Snowflake and BigQuery. Now you can not only manually map to binary, but we support automapping of binary fields from MySQL as well as PostgreSQL.
- Snowflake's Variant and Array data types are now available in the UI.
- We now delete consolidations after their event type is disabled or deleted, so they will not fail or make a mess.
- We added a clear notification when an initial dump/load snapshot of your MySQL tables or MongoDB collections is complete, so you have clear feedback that your historical data is ready to go.
- We can now properly handle events with Unicode in the event type.
- The event type dropdown on the samples area of the input view wasn't showing all of that input's event types. So, we fixed that.
- The Google Analytics report wasn't being run at 5am PST as expected, so now it is.
- We fixed an issue where the mapper wasn't flagging mismatches between table data and mapping data, so now it's clear.