Amazon Redshift
- Cloud Databases
Seamlessly integrate Yurbi with Amazon Redshift to harness the power of your data warehouse, enabling advanced reporting and dynamic dashboards for in-depth analytics.
About
Amazon Redshift is a fully managed, petabyte-scale cloud data warehouse service provided by Amazon Web Services (AWS). Designed for high-performance analytics, Redshift enables businesses to efficiently analyze large volumes of data and gain valuable insights. It supports complex queries and offers fast query performance through its columnar storage and parallel processing capabilities. With features like automated backups, scaling, and robust security measures, Amazon Redshift ensures high availability and data integrity. When integrated with Yurbi, users can tap into real-time data from Amazon Redshift to create detailed reports and interactive dashboards that drive informed decision-making.
Supported Versions
Amazon Redshift operates as a single service without distinct version numbers as seen in traditional database systems.
Integration Capabilities
- Live query read-only access to your data source
- Support for table owner/schema
- Compatibility with Views
- Dynamic Data Source Connection Strings
Requirements
- SQL User ID with read-only access
- Network/Firewall access to the Redshift cluster
Support
Integration FAQs
-
How do I get started with this integration?
If you have admin privileges, navigate to Settings > Integration and select Create a New App for the data source you want to use.
-
What types of data can I access through this integration?
Yurbi generates SQL queries dynamically using the official database driver, ODBC driver, or API endpoint. Through this integration, you can access a variety of structured data from your data source, such as tables, views, and results from stored procedures in MSSQL and MySQL.
-
How do I refresh the data in Yurbi after making changes in my database?
Yurbi performs live queries against your data source, ensuring that every time a report or dashboard is executed, it retrieves the most up-to-date data available. This means you always have access to the latest information without needing to manually refresh anything.
-
Can Yurbi cause any damage or harm to my data source?
Yurbi performs read-only queries against the connected data source, meaning it cannot write or modify any data. However, if queries are designed to pull excessive amounts of data, they can consume significant resources, potentially leading to timeouts or increased load that may affect overall performance.