How to enable Javascript

SQL Best Practices

Hello World! Test Cloud Connect with the Sample BigQuery Connection by Lytics
Interested in testing Cloud Connect with sample data? You’re in luck! The Sample BigQuery Connection by Lytics is available for creating test audiences before connecting to your own data warehouse.…
- 1 yr ago
- 99
- 2
- Documentation
Managing Complex Joins with SQL Views
Among the advantages of Cloud Connect is the flexibility of data that can be included in an Audience using the power of SQL. However, challenges can arise as your SQL logic becomes complex,…
- 1 yr ago
- 21
- 1
- SQL Best Practices
Supported Data Types by Data Warehouse Connection Type
Overview When constructing your audience queries it's important to keep in mind which data types are supported by your data warehouse. Sticking to the data types listed below by data warehouse…
- 1 yr ago
- 21
- 1
- SQL Best Practices
Duplicate Column Names: Use Projected Column Names
Overview Note: Lytics is actively working toward a solution for the error described here. When building a Cloud Connect audience scenarios may arise where the same data type exists in multiple…
- 1 yr ago
- 19
- 2
- SQL Best Practices
Table Naming Convention
When writing a query in the Audience Builder please note table names must exactly match the format used in the data warehouse. Table naming format if slightly different for each of the supported…
- 1 yr ago
- 16
- 1
- SQL Best Practices

Back to top

Categories

View all topics

Tags

Top contributors

View all members

Recent activity