Recently I’ve been working with secure data sharing in Snowflake.
We’ve not yet shared our data using a normal private share to another Snowflake account, but I’ve tested everything. Using SIMULATED_DATA_SHARING_CONSUMER and setting the consumer id to my expected account, I was getting data back from the share and everything was working fine.
Today, however, we got a request to share our data to a managed reader account. I created the account, logged in, copied the share into a database, and could see all of my secure views. But, when I went to query the view, some of the views that were previously working, suddenly were not. All I got back was an ominous “Error in secure object.”
Read more...I’ve recently had occasion to start writing a series of services on the AWS stack using the Serverless Framework. Serverless is a great framework, but I really don’t like having to deploy stuff to AWS to test DynamoboDB streams, SQS queues, etc. That’s where LocalStack comes in. LocalStack lets you host an entire AWS ecosystem locally so you can test “all the things” without actually deploying anything.
LocalStack works great, but I discovered there are a few undocumented things that you’ll need to know to get your stuff working correctly locally.
Read more...I’ve been using Z Shell for over a year now and I’ve been very pleased with it. Honestly, I should have moved off macOS’s antiquated default Bash ages ago. Below is an update on where my .zshrc is sitting a while down the road.
I keep the Oh My ZSH plug-ins pretty light. Partially because I want to keep startup times low and partially because I can’t remember the commands anyways.
Read more...I recently replaced my iMac with an M1 Mac mini and did an entire rework of my desk setup. With the iMac gone, I was finally able to buy a proper 4k montior to share between my work laptop and my personal workstation. I was also able to upgrade my keyboard to a Varmilo Miya Pro and get a new mouse. Since I would be switching between my work and personal machines several times a day, I wanted a simple and reliable system to share external devices between my systems.
Read more...Drafts 5 for Mac recently introduced the ability to do some basic scripting in JavaScript as an action in the application. Each time I prepare a sermon, the first step for me is to lookup the readings for the week on LectServe and then paste the readings into Drafts where I can start doing sermon preparation and, eventually, write my sermon. As soon as I saw actions and scripting introduced for Drafts, I knew I’d have to automate my sermon prep process.
Read more...Sometimes you need to run cron or other applications in your Debian container that rely on the system running in localtime. In Debian 9, switching to localtime wasn’t the easiest thing in the world. With Debian 10, however, you can switch your container to another timezone with just a few commands.
First you need to install tzdata.
]
]
]
]
]RUN apt-get install tzdata -y
Then you need to make a link between the timezone you want to move to in /usr/share/zoneinfo and /etc/localtime.
