staaldraad

# Gawk version
# Remote
grep -v "rem_address" /proc/net/tcp  | awk  '{x=strtonum("0x"substr($3,index($3,":")-2,2)); for (i=5; i>0; i-=2) x = x"."strtonum("0x"substr($3,i,2))}{print x":"strtonum("0x"substr($3,index($3,":")+1,4))}'

# Local
grep -v "rem_address" /proc/net/tcp | awk  '{x=strtonum("0x"substr($2,index($2,":")-2,2)); for (i=5; i>0; i-=2) x = x"."strtonum("0x"substr($2,i,2))}{print x":"strtonum("0x"substr($2,index($2,":")+1,4))}'

# No Gawk
# Local
grep -v "rem_address" /proc/net/tcp  | awk 'function hextodec(str,ret,n,i,k,c){

angristan

Elasticsearch settings for single-node cluster

1 shard, 0 replica.

For future indices

Update default template:

curl -X PUT http://localhost:9200/_template/default -H 'Content-Type: application/json' -d '{"index_patterns": ["*"],"order": -1,"settings": {"number_of_shards": "1","number_of_replicas": "0"}}' 

timvw

resource "snowflake_unsafe_execute" "volume" {
  execute = <<EOT
CREATE OR REPLACE EXTERNAL VOLUME ${var.external_volume_name}
   STORAGE_LOCATIONS =
      (
         (
            NAME = '${var.external_volume_bucket_name}'
            STORAGE_PROVIDER = 'S3'
            STORAGE_BASE_URL = 's3://${var.external_volume_bucket_name}'
            STORAGE_AWS_ROLE_ARN = '${var.snowflake_iam_role_arn}'