Category: Amazon Web Services

AWS features to protect data in Amazon QuickSight

AWS

Amazon QuickSight ensures that AWS will be responsible for protecting the data, controlling the data to handle customer content and personal data. This protection can be done through AWS account credentials – setting up for individual user accounts with AWS identity and Access Management (IAM). Data is also protected by Multi-Factor Authentication (MFA), Secure Socket Layer (SSL) and by using advanced managed security services such as Amazon Macie. Users should note that content being delivered to Amazon S3 bucket may contain some sensitive data and it should be removed from the bucket to protect before sending it. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Amazon QuickSight – Using Query Limits

Dataset SPICE

If importing data is not being done through SPICE then Query limits are being used. Otherwise timeouts can occur. ● Each result from a data query can have up to 2000 columns and each column can have up to 127 Unicode characters.● If a larger set of data is being retrieved you can reduce the size of the data by applying filters or u can deselect the columns.● This query limit has a 2-minute limit for generating a visual, or an optional dataset sample. DataTerrain, with years of experience and reliable experts, is ready to assist. We have served more than 250 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Read More +

Unique features of Amazon QuickSight

Amazon Quicksight

Amazon Quicksight differentiates from other BI tools with the following unique features: ● AutoGraph – Visuals can be created in many different ways but if you choose the “AutoGraph” icon and select the necessary fields then Amazon QuickSight will determine the appropriate visual type in which the selected fields will be populated. This feature is very helpful when you don’t know what type of visualization is required for your report. ● SPICE – SPICE engine is an in-memory optimized engine for fast and ad hoc data visualization. It stores your data in a system architected for high availability till you choose to delete it. The performance of the database can be improved a lot by importing the data’s into this particular engine. ● ML Insights – Amazon QuickSight uses machine learning technology to continuously analyze all your data, detect anomalies, and send proactive email alerts. No need of manual analysis, custom development or Machine Learning Domain expertise is required. It automatically summaries into a plain language and embeds them into QuickSight dashboards which create shared understanding of the data within the organization and helps you make decision faster. DataTerrain, with years of experience and reliable experts, is ready to assist. […]

Read More +

HOW TO SHARE DATA IN SNOWFLAKE

Azure Snowflake

Snowflake enables sharing of data through named Snowflake objects called shares which supports data sharing by sharing tables, secure views, and secure UDFs in our Snowflake database (Data Provider) with other Snowflake accounts (Data Consumer). If the data consumer does not have a Snowflake account then we can create a reader account through which we can share data without requiring the consumer to become a Snowflake customer. All database objects shared between accounts are read-only so data consumers cannot make any change to the data. In secure data sharing, data is not actually copied or transferred between accounts; it means that shared data does not take up any storage in a consumer account. The only charges to consumers are for the compute resources used to query the shared data. In the case of a reader account, the provider will be charged for the compute resources used by users in the reader account. Data shares and reader accounts must be located in the same region of the same Cloud Provider (AWS, Azure or GCP). Data consumers cannot re-share the shared data with other accounts. In reader accounts data consumers are allowed to create new users. To start sharing data we need […]

Read More +

Benefits of using Jaspersoft with AWS

Jaspersoft reporting

Jaspersoft supports business intelligence reporting and analytics on the AWS cloud platform. The following are the major features and benefits of Jaspersoft with AWS. • AWS offers a secure cloud services platform, offering to compute power, database storage, content delivery that enable the business scale and grow. • Users can create interactive reports, dashboards and data visualizations and capable to quickly connect to Amazon RDS, Redshift and EMR data sources. • There is no data or user limits and no additional fees. • Jaspersoft for AWS is quick and easy to set up and offers a cost-efficient cloud analytics platform. • Provides a straightforward approach for installation and reports and dashboards can be created by a few clicks in less amount of time. DataTerrain with years of experience and reliable experts is ready to assist. We have served more than 200 customers in the US and over 70 customers worldwide. We are flexible in working hours and do not need any long term binding contracts.

Read More +