August 2022
Beginner to intermediate
463 pages
9h 22m
Chinese
Content preview from Tableau Prep即学即用
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
186
｜
第
20
章
可能会受到限制，直到你已经证明了你的技能和理解力，可以信任你对表和数据的
访问权限，如果不正确地使用或更改，这些表和数据会产生更大的、潜在的灾难性
影响。
尽管如此，大多数组织都会控制他们的工具和权限，以确保生产数据源不会受到影
响，直到更改在许多环境中得到测试。因此，这种“最重大的风险”实际上可能是
风险最小的，因为它控制得比较严格。
Prep Builder
用户需要
sandpit
（沙坑）或
sandbox
（沙箱）空间来研究和探索，以学
习和改进对数据库表进行写操作的技能。正如本章前面所介绍的那样，能够向数据
库写表有很多好处，但在利用这些好处之前，你需要有适当的技能。沙坑可以让你
在一个空间里编写数据库表，在这个空间里，它们不会被看作是生产表，也不会被
其他人意外地使用，而且在这个空间里，你可以更改或删除表，而不必担心这些更
改会影响组织的生产业务。
20.4
小结
向数据库写入数据的能力是一个很强的技能，可以添加到你的数据准备工具箱中。
虽然有覆盖或删除数据且不可恢复的风险，但一般来说，数据库的权限会阻止你这
样做。通过使用
Prep Builder
写入数据库的功能，并通过
Prep Conductor
定期进行
刷新调度，你可以在
Prep
中创建和产品化解决方案，向最终用户提供干净、更新及
时的数据。
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.