[SAA + SAP] 19. Database & Redshfit
2023-09-14 08:59:12 时间
- ETL: Extra data from S3 or RDS
- Transform data in Glue
- Load data into RedShift, or other Data Warehouse
- Craw the data
- Search for any field
- Partially matches
- Data warehouse
- High perofrmance
- Can write SQL
- Copy data can through Enahced VPC Routing
- Redshift is provisioned, so it's worth it when you have a sustained usage (otherwise use Athena if the queries are sporadic)
- Redshift has no "Multi-AZ"
- So for DR, you need to use Snapshot
- CRR is available
- Data source are be from
- Kinesis data firehose
- S3
- EC2 (suitable for batch operation)
- SQL query against S3
- Must use Redshift cluster
相关文章
- zookeeper启动错误 ---- Unable to load database on disk
- 【DataGuard】ORA-00313, ORA-00312, ORA-27037 in Standby Database
- Attempt to fetch logical page (...) in database 2 failed. It belongs to allocation unit xxxx not to xxx
- Enterprise Library深入解析与灵活应用(2): 通过SqlDependency实现Cache和Database的同步
- [AWS DA] Database types & SSL
- [SAA + SAP] 19. Database & Redshfit
- 172. SAP UI5 两大表格控件 sap.ui.table.Table 和 sap.m.Table 的使用场景辨析
- [ChatGPT 勘误] SAP UI5 的 sap.ui.base.Object
- SAP UI5 clone 到 WebIDE后,加载 sap-ui-core.js 后出现 404 Not found 错误的原因
- SAP UI5 workthrough 12 sap.m.shell
- SAP UI5 jQuery.sap.includeStyleSheet
- sap.ui.require in SAP UI5 and require in nodejs
- SAP UI5应用的一个调试参数 - sap-ds-debug=true
- SAP ui5 sap.ui.getCore().getUIArea
- 什么是SAP HANA Database Procedure(数据库过程)
- There is no database available的错误消息
- SAP UI5 日期类型 sap.ui.model.type.Date 的解析格式问题分析
- SAP UI5 sap.ui.vk 命名空间内的控件介绍
- SAP UI5 的 sap-ui-bootstrap script 脚本标签各属性解析
- SAP UI5 应用 index.html 里 data-sap-ui-resourceroots 指令的含义和作用
- Database之SQLSever:SQL命令实现的高级案例集合之单表/多表(筛选、统计个数)之详细攻略
- Database之SQLSever:SQL函数(字符串函数、数学函数、文本和图像函数、日期和时间函数、系统函数等)相关概念及其相关案例之详细攻略
- 多种方法解决Error querying database. Cause: java.sql.SQLException: No value specified for parameter 1
- 小型文件数据库 (a file database for small apps) SharpFileDB
- MySQL出现Ignoring query to other database的问题
- Database Firewall——mysql也是支持的
- Liquibase----XML格式通过update更新H2 Database数据库