8/29/2023 0 Comments Redshift mysql![]() We understand that this is because we are not using the correct encoding. The only problem we have is that it doesn't import wellformed data and takes some garbage characters. We used CanvasDataViewer to import the data into our SQL SERVER DW, as you suggested, and worked wonders so far. I'll add more as it comes up, and hope to hear more from others! Those are a few things that come to mind initially. Not really a consideration, but there is a nice GitHub repository with Hosted Data Query Examples.For example, having some data in MS SQL Server and some data in Redshift might mean that your queries in SQL Server won't be able to access the Redshift data. Tableau) allow you to blend sources so it is easier to explore data across databases. Do you need to integrate Canvas Data with other data sources? Some tools (e.g.and are two folks whom I have seen being fairly active in this realm. And here's another good post in the community about scripts for pulling data into MySQL. How will you pull the data into your DW? and his team at Eastern Michigan University created an application that would download all the Canvas Data flat files and insert them into tables in SQL Server. ![]() Having a smaller cluster/node may not be an issue in most cases, but it's worth being aware of. In most cases that is fine, but the Requests table - which houses lots of interesting information about user engagement - is huge in most cases (for us, going back to 2015, the table is about 1.7 billion rows).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |