java -Djava.library.path=./DynamoDBLocal_lib -jar DynamoDBLocal.jar -sharedDb
var AWS = require("aws-sdk");
AWS.config.update({
<html> | |
<body> | |
<script src="https://cdn.jsdelivr.net/npm/gun/gun.js"></script> | |
<script src="https://cdn.jsdelivr.net/npm/gun/sea.js"></script> | |
<script src="https://cdn.jsdelivr.net/npm/gun/lib/open.js"></script> | |
<script src="https://cdn.jsdelivr.net/npm/gun/lib/not.js"></script> | |
<div id="logger"></div> |
/////////////////////////////////// | |
// On my side - logged in as myself | |
/////////////////////////////////// | |
var myPair = gun.user()._.sea; | |
// retrieve bob's user | |
var bob = gun.user(bobPublicKey); | |
// generate encryption secret using bob's epub and my pair | |
// this means only bob will be able to generate this secret | |
var secret = await SEA.secret(bob.epub, myPair) | |
// encrypt the data using the secret |
// https://jsbin.com/rasuwilojo/6/edit?js,console | |
(async () => { | |
///////////////////////////////////////////////////////////////// | |
// Instead of logging in with actual users, we are | |
// going to generate SEA pairs which is basically the same thing | |
///////////////////////////////////////////////////////////////// | |
// User 1 encrypts one message |
<h1> WOW! </h1> |
To transform your Databricks table with columns "28 September, 2023", "04", and "23" into a Databricks date format using SQL, you can use SQL queries within Databricks. You'll need to concatenate the columns to create a string representing the full timestamp and then cast it to a timestamp type. Here's the SQL query to achieve this:
SELECT
TO_TIMESTAMP(CONCAT_WS(' ', `28 September, 2023`, `04`, `23`), 'dd MMMM, yyyy HH:mm') AS timestamp_col
FROM
yourTable;
In this SQL query: