Configuring a Security GroupĬreate a security group in the same VPC as the Redshift cluster that you are connecting to Sisense. If you encounter problems connecting to Amazon RedShift, see this article in the support forum. The tables are added to your schema in Sisense. After you have selected all the relevant tables, click Done.See Creating Custom Live Table Queries for more information. See Importing Data with Custom Queries for more information.Ĭlick + to customize the data you want to access with SQL. You can disable this by toggling the Import Relationships switch.Ĭlick + to customize the data you want to import with SQL. (Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube or live model.When you select the table or view, two new options are displayed at the bottom of the list, Import Relationships and Add Custom Import SQL. You can click next to the relevant table or view to see a preview of the data inside it. From the Tables list, select the relevant table or view you want to work with.You can find the schema easily by filtering for it using the Search field at the top of the list.Īll tables and views associated with the database appear in a new window. For Linux, under the Select Data tab, on the left side is a list of schemas located in your data source.For a full list of connection string options, click here. (Optional) In Additional Parameters, enter additional configuration options by appending key-value pairs to the connection string (e.g., port=5433 ).( Optional) Select Encrypt Connection to configure the driver to encrypt all communication with Redshift before sending it over the network, and then select Trust Server Certificate.Default Database: Enter the name of the default database you will use for authentication.User Name and Password: Enter your Redshift account credentials.To connect to a database running on your own computer, enter localhost. By default, the port is 5439, for example: :5439. This server address should include the endpoint, port, and database. Location: Enter the Amazon Redshift cluster endpoint.Click Amazon Redshiftto open the Amazon Redshift settings.In the data model, click the Add Data dialog box is displayed.Open a Live model, or create a new live model.Open an ElastiCube or create a new data model.You can import your Redshift data into a Sisense ElastiCube or Live models, using Live Connect. Sisense enables quick and easy access to databases, tables and views contained within Amazon Redshift databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |