Please enable JavaScript.
Coggle requires JavaScript to display documents.
Quicksight Aws - Coggle Diagram
Quicksight Aws
Visualization
Drill-Down
Filters
Visuals
Pivot Tables
Group
Heat Maps :fire:
KPI visual
Database Source
RDS
MySQL
Security Group
Inbound
Source
My IP
MySQL Client
If Windows
mysql -h <RDS url> -P 3306 -u <username> -p
RDS PWD
Quicksight
Dataset
RDS
MySQL if other region
Endpoint URL
SG
If othr regions
Types
SPICE
Join
Calculated Field
Start only
Query
1 table only
Calculated Field
Always
NoSQL
Through
Redshift
CSV
SQL
Data Preparation
Workflow
S3
EMR
S3
Redshift
Quicksight
Loading
Request Types
Direct Query
SPICE
Database
Yes
Direct Query
Joint Table :check:
Calculated Fields :check:
No
SPICE
Joint Table :red_cross:
S3 Connexion
Load
JSON
URI
filename
URIPrefix
Bucket name
Permissions
Quicksight
Account Setting
Allow S3
Communicate
Export
CSV
Share
Data Set
User
Analysis only
Owner
Change
Delete
Analysis
Co-owner
Edit
Dashboard
Read Only
Filter
Subscription
More users
SPICE Space
Mobile App
Users
Type
Quicksight Only
email
IAM
Same
AWS Account
Role
User
Admin
Fields
Operators
Arithmetic
+
-
Comparison
Functions
Numeric
String
Conditional
Date
Data refresh
Now
Scheduled :alarm_clock: